﻿<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>方向条件-按照SQL计算</title>
    <!--SQL编辑器-->
    <link href="../../Scripts/easyUI145/themes/default/easyui.css" rel="stylesheet" type="text/css" />
    <link href="../../Scripts/CodeMirror/lib/codemirror.css" rel="stylesheet" />
    <link href="../../Scripts/CodeMirror/addon/hint/show-hint.css" rel="stylesheet" />
    <script src="../../Scripts/CodeMirror/lib/codemirror.js"></script>
    <script src="../../Scripts/CodeMirror/addon/edit/matchbrackets.js"></script>
    <script src="../../Scripts/CodeMirror/mode/sql/sql.js"></script>
    <script src="../../Scripts/CodeMirror/addon/hint/show-hint.js"></script>
    <script src="../../Scripts/CodeMirror/addon/hint/sql-hint.js"></script>
    <script src="../../Scripts/LoadSql.js"></script>
    <script type="text/javascript" src="../../Scripts/bootstrap/js/jquery.min.js"></script>
    <script type="text/javascript" src="../../Scripts/bootstrap/js/bootstrap.min.js"></script>

    <link href="../../Style/skin/css/Default.css" rel="stylesheet" />
    <link href="../../Style/skin/adminfont/iconfont.css" rel="stylesheet" />
    <link href="../../Scripts/bootstrap/css/bootstrap.min.css" rel="stylesheet" />

    <script src="../../Scripts/QueryString.js" type="text/javascript"></script>
    <script src="../../Scripts/config.js" type="text/javascript"></script>
    <script src="../../Comm/Gener.js" type="text/javascript"></script>
    <script src="../Admin.js" type="text/javascript"></script>

    <script src="../../Scripts/easyUI/jquery-1.8.0.min.js" type="text/javascript"></script>
    <link href="../../../DataUser/Style/ccbpm.css" rel="stylesheet" type="text/css" />
    <base target="_self" />

    <script type="text/javascript">

        function Esc() {
            if (event.keyCode == 27)
                window.close();
            return true;
        }
        var condOrAnd = GetQueryString("CondOrAnd");
        //初始化页面函数.....
        $(function () {

            var mypk = GetQueryString("MyPK");
            var cond = new Entity("BP.WF.Template.Cond");
            cond.MyPK = mypk;
            if (mypk != null && mypk!=undefined && mypk!="") {
                cond.SetPKVal(mypk);
                cond.RetrieveFromDBSources();
                var docs = cond.OperatorValue;

                docs = docs.replace(/~/g, "'");
                document.getElementById("TB_SQL").value = docs;
                document.getElementById("TB_Note").value = cond.Note;
                editor.setValue(document.getElementById("TB_SQL").value);
            }
            

        });

        //执行保存..
        function Save() {
 
            var sqlVal = editor.getValue();
            var note = document.getElementById("TB_Note").value;
            if (sqlVal == "") {
                alert('请输入参数.');
                return;
            }
            if (note == "") {
                alert('请输入备注说明.');
                return;
            }

            var handler = new HttpHandler("BP.WF.HttpHandler.WF_Admin_Cond");
            handler.AddUrlData();
            handler.AddPara("TB_Docs", sqlVal);
            handler.AddPara("TB_Note", note);

            var data = handler.DoMethodReturnString("CondBySQL_Save");
            if (data.indexOf('err@') == 0) {
                $("#Msg").html("<font color=red>" + data + "</font>");
                return;
            }

            if (data.indexOf('url@') == 0) {
                var url = data.replace('url@', '');
                SetHref(url);
                return;
            }
            Back();


        }


        //装载模版.
        function LoadTemplate() {

            //打开方向条件.
            var url = "../SettingTemplate.htm?TemplateType=CondBySQL&CondType=2";
            var newWindow = window.open(url, 'SQL模板', 'width=900,height=700,top=100,left=300,scrollbars=yes,resizable=yes,toolbar=false,location=false,center=yes,center: yes;');
            newWindow.focus();

        }
        //返回.
        function Back() {
            var url = GetHrefUrl();

            url = url.replace('CondBySQL.htm', 'List.htm');
            if (url.indexOf("MyPK=") != -1) {
                url = url.replace("&MyPK=" + GetQueryString("MyPK"), "");
            }
            SetHref(url);
           
        }
    </script>
</head>
<body onkeypress="Esc();">
    <div class="container-full">
        <div class="attrnode-bar-header">
            <span class="pull-right">
                <!--<input type="button" value="加载模版" onclick="LoadTemplate()" />-->
                <button id="Btn_Save" name="Btn_Save" onclick="Save();">保存</button>
                <!--<input type="button" value="删除" onclick="Delete()" />-->
                <button id="Btn_Back" name="Btn_Back" onclick="Back();">返回</button>

            </span>
            <strong>方向条件-按照SQl</strong>
        </div>
        <form id="cc">
    
            <table class="table">
              
                <tr>
                    <td style="width: 20%;">
                        要执行的SQL:
                    </td>
                    <td>
                        <textarea rows="4" style="width: 95%;" id="TB_SQL" name="TB_Docs"> </textarea>
                    </td>
                </tr>
                <tr>
                    <td>
                        备注(不为空):
                    </td>
                    <td>
                        <input type="text" value="" id="TB_Note" name="TB_Note" style="width: 95%;" />
                    </td>
                </tr>
            </table>

            <div style="text-align: left">
                <h4>
                    &nbsp; &nbsp; &nbsp; &nbsp;帮助
                </h4>
                <ul>
                    <ul>
                        <li>在文本框里设置一个查询SQL，它返回一行一列。比如: SELECT COUNT(*) AS Num FROM MyTable WHERE NAME='@MyFieldName'。</li>
                        <li>该SQL参数支持系统的表达式，什么是ccflow的表达式请查看说明书。</li>
                        <li>当前登录信息变量: @WebUser.No, @WebUser.Name, @WebUser.FK_Dept.</li>
                        <li>系统就会获取该返回的值把它转化为decimal类型</li>
                        <li>如果该值大于零，该条件就是成立的，否则不成立，不成立就不到达这个节点。</li>
                    </ul>
                </ul>
            </div>
        </form>
        <center>
            <div id="Msg" />
        </center>
    </div>
</body>
</html>
